package com.ruoyi.project.mapper;

import java.util.List;
import com.ruoyi.project.domain.YqgInformationRoom;

/**
 * 房间基础信息Mapper接口
 *
 * @author dr
 * @date 2023-04-17
 */
public interface YqgInformationRoomMapper
{
    /**
     * 查询房间基础信息
     *
     * @param ID 房间基础信息主键
     * @return 房间基础信息
     */
    public YqgInformationRoom selectYqgInformationRoomByID(Long ID);

    /**
     * 查询房间基础信息列表
     *
     * @param yqgInformationRoom 房间基础信息
     * @return 房间基础信息集合
     */
    public List<YqgInformationRoom> selectYqgInformationRoomList(YqgInformationRoom yqgInformationRoom);

    /**
     * 新增房间基础信息
     *
     * @param yqgInformationRoom 房间基础信息
     * @return 结果
     */
    public int insertYqgInformationRoom(YqgInformationRoom yqgInformationRoom);

    /**
     * 修改房间基础信息
     *
     * @param yqgInformationRoom 房间基础信息
     * @return 结果
     */
    public int updateYqgInformationRoom(YqgInformationRoom yqgInformationRoom);

    /**
     * 删除房间基础信息
     *
     * @param ID 房间基础信息主键
     * @return 结果
     */
    public int deleteYqgInformationRoomByID(Long ID);

    /**
     * 批量删除房间基础信息
     *
     * @param IDs 需要删除的数据主键集合
     * @return 结果
     */
    public int deleteYqgInformationRoomByIDs(Long[] IDs);


    List<YqgInformationRoom> selectNormalCount();

    List<YqgInformationRoom> selectNoralList();

    List<YqgInformationRoom> selectByNumber(String number);

    List<YqgInformationRoom> selectByType(String roomType);

    int updateByRoom(YqgInformationRoom yqgInformationRoom);

    YqgInformationRoom selectByRoomNumber(String roomNumber);

    List<YqgInformationRoom> selectStatusCount();

    List<YqgInformationRoom> selectByWake();

    int updateByRoomByTime(YqgInformationRoom yqgInformationRoom);

    List<YqgInformationRoom> selectRoomListByClean(YqgInformationRoom yqgInformationRoom);

    List<YqgInformationRoom> selectLatterInforamtion(YqgInformationRoom yqgInformationRoom);
}
